ITERATE Statement

This MariaDB tutorial explains how to use the ITERATE statement in MariaDB with syntax and examples.

Description

In MariaDB, the ITERATE statement is used when you are want a loop body to execute again. It is used within the LOOP statement, WHILE statement, and REPEAT statement.

Syntax

The syntax for the ITERATE statement in MariaDB is:

ITERATE label_name;

Parameters or Arguments

label_name

The name of the loop to repeat.

Note

• You use the ITERATE statement to execute the loop again.

Example

Let's look at an example that shows how to use the ITERATE statement in MariaDB:

DELIMITER //

 

CREATE FUNCTION CalcValue ( starting_value INT )

RETURNS INT DETERMINISTIC

 

BEGIN

 

   DECLARE total_value INT;

 

   SET total_value = 0;

 

   label1: LOOP

     SET total_value = total_value + starting_value;

     IF total_value < 450 THEN

       ITERATE label1;

     END IF;

     LEAVE label1;

   END LOOP label1;

 

   RETURN total_value;

 

END; //

 

DELIMITER ;

In this ITERATE example, we have created a loop called label1 using the LOOP statement.

The ITERATE statement would cause the loop to repeat while total_value is less than 450. Once total_value is greater than or equal to 450, the LEAVE statement would terminate the LOOP.